HDP_plots.csv
& HDP_1997_2009.csv Data with
pointblankHere we use pointblank to create a data validation
report. In the resulting table at the end, any failing tests should have
a CSV button that lets you download a .csv file of just the rows of data
that don’t pass that particular validation step.
Action levels: strict criteria (error if any rows fail)
| Pointblank Validation | |||||||||||||
| Data Validation
tibbleWARN
1
STOP
0.02
NOTIFY
—
|
|||||||||||||
| STEP | COLUMNS | VALUES | TBL | EVAL | UNITS | PASS | FAIL | W | S | N | EXT | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Height is measured to nearest cm
|
— |
|
✓ |
57K |
57K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 2 | Shoots is interger
|
— |
|
✓ |
57K |
57K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 3 | Number of inflorescences is integer
|
— |
|
✓ |
2K |
2K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 2023-05-25 21:58:27 EDT < 1 s 2023-05-25 21:58:27 EDT | |||||||||||||
Action levels: strict criteria (error if any rows fail)
| Pointblank Validation | |||||||||||||
| Data Validation
tibbleWARN
1
STOP
0.02
NOTIFY
—
|
|||||||||||||
| STEP | COLUMNS | VALUES | TBL | EVAL | UNITS | PASS | FAIL | W | S | N | EXT | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | col_vals_in_set()
|
|
✓ |
67K |
67K1.00 |
00.00 |
— |
○ |
— |
— | |||
| 2 | col_vals_in_set()
|
|
✓ |
67K |
67K1.00 |
00.00 |
— |
○ |
— |
— | |||
| 2023-05-25 21:58:28 EDT < 1 s 2023-05-25 21:58:28 EDT | |||||||||||||
Action levels: error if any rows fail.
| Pointblank Validation | |||||||||||||
| Data Validation
tibbleWARN
1
STOP
0.02
NOTIFY
—
|
|||||||||||||
| STEP | COLUMNS | VALUES | TBL | EVAL | UNITS | PASS | FAIL | W | S | N | EXT | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | duplicated rows
|
— | — |
|
✓ |
67K |
67K1.00 |
00.00 |
— |
○ |
— |
— | |
| 2 | col_vals_not_null()
|
— |
|
✓ |
67K |
67K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 3 | Check for duplicate ID's within each year
|
— |
|
✓ |
3K |
3K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 4 | Check for duplicate ID's within each year
|
— |
|
✓ |
4K |
4K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 5 | Check for duplicate ID's within each year
|
— |
|
✓ |
5K |
5K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 6 | Check for duplicate ID's within each year
|
— |
|
✓ |
6K |
6K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 7 | Check for duplicate ID's within each year
|
— |
|
✓ |
6K |
6K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 8 | Check for duplicate ID's within each year
|
— |
|
✓ |
6K |
6K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 9 | Check for duplicate ID's within each year
|
— |
|
✓ |
6K |
6K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 10 | Check for duplicate ID's within each year
|
— |
|
✓ |
6K |
6K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 11 | Check for duplicate ID's within each year
|
— |
|
✓ |
7K |
7K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 12 | Check for duplicate ID's within each year
|
— |
|
✓ |
5K |
5K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 13 | Check for duplicate ID's within each year
|
— |
|
✓ |
6K |
6K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 14 | Check for duplicate ID's within each year
|
— |
|
✓ |
6K |
6K1.00 |
00.00 |
— |
○ |
— |
— | ||
| 2023-05-25 21:58:28 EDT 2.1 s 2023-05-25 21:58:30 EDT | |||||||||||||
Action levels: warn if \(\geq\) 1 rows fail conditions, error if \(\geq\) 2% of rows fail conditions.
| Pointblank Validation | |||||||||||||
| Data Validation
tibbleWARN
1
STOP
0.02
NOTIFY
—
|
|||||||||||||
| STEP | COLUMNS | VALUES | TBL | EVAL | UNITS | PASS | FAIL | W | S | N | EXT | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | shoots between 0 and 20
|
|
✓ |
67K |
67K0.99 |
80.01 |
● |
○ |
— |
||||
| 2 | height between 0 and 200cm
|
|
✓ |
67K |
67K0.99 |
20.01 |
● |
○ |
— |
||||
| 3 | infloresences between 0 and 3
|
|
✓ |
67K |
67K0.99 |
150.01 |
● |
○ |
— |
||||
| 2023-05-25 21:58:31 EDT < 1 s 2023-05-25 21:58:31 EDT | |||||||||||||
Action levels: warn if \(\geq\) 1 rows fail conditions, error if \(\geq\) 2% of rows fail conditions.
| Pointblank Validation | |||||||||||||
| Check growth & regression
tibbleWARN
1
STOP
0.02
NOTIFY
—
|
|||||||||||||
| STEP | COLUMNS | VALUES | TBL | EVAL | UNITS | PASS | FAIL | W | S | N | EXT | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | |% change in height| < 200%
|
|
✓ |
67K |
66K0.99 |
4200.01 |
● |
○ |
— |
||||
| 2 | |∆ height| < 100cm
|
|
✓ |
67K |
67K0.99 |
110.01 |
— |
● |
— |
||||
| 3 | |∆ shoot number| < 5
|
|
✓ |
67K |
67K0.99 |
2010.01 |
— |
● |
— |
||||
| 2023-05-25 21:58:32 EDT < 1 s 2023-05-25 21:58:32 EDT | |||||||||||||
Action levels: warn if \(\geq\) 1 rows fail conditions, error if \(\geq\) 2% of rows fail conditions.